Profiling Report

Dataset statistics

Number of variables	33
Number of observations	120692
Missing cells	907331
Missing cells (%)	22.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.3 MiB
Average record size in memory	272.0 B

Variable types

Categorical	14
Numeric	8
DateTime	3
Text	5
Boolean	2
Unsupported	1

Alerts

`appointment_status` is highly overall correlated with `business_name` and 5 other fields	High correlation
`business_name` is highly overall correlated with `appointment_status` and 3 other fields	High correlation
`cancelled` is highly overall correlated with `appointment_status` and 7 other fields	High correlation
`case_type` is highly overall correlated with `opened_case_name`	High correlation
`concession_type` is highly overall correlated with `business_name` and 3 other fields	High correlation
`customer_type` is highly overall correlated with `concession_type` and 1 other fields	High correlation
`notice` is highly overall correlated with `cancelled` and 1 other fields	High correlation
`opened_case_name` is highly overall correlated with `case_type` and 1 other fields	High correlation
`patient_type` is highly overall correlated with `appointment_status` and 4 other fields	High correlation
`percentage_good_appointments_and_missed_appointments_before_can` is highly overall correlated with `appointment_status` and 4 other fields	High correlation
`referred` is highly overall correlated with `business_name` and 2 other fields	High correlation
`session_left` is highly overall correlated with `opened_case_name`	High correlation
`total_closed_invoices_before_appointemnt` is highly overall correlated with `total_good_appointments_before_cancelled_appointment`	High correlation
`total_cxl_appointments_before_cancelled_appointment` is highly overall correlated with `appointment_status` and 4 other fields	High correlation
`total_good_appointments_before_cancelled_appointment` is highly overall correlated with `appointment_status` and 6 other fields	High correlation
`patient_status` is highly imbalanced (87.9%)	Imbalance
`concession_type` is highly imbalanced (60.3%)	Imbalance
`title` is highly imbalanced (52.7%)	Imbalance
`state` is highly imbalanced (82.9%)	Imbalance
`sex` is highly imbalanced (62.5%)	Imbalance
`opened_case_name` has 35575 (29.5%) missing values	Missing
`total_open_invoices_before_appointemnt` has 40434 (33.5%) missing values	Missing
`session_left` has 93690 (77.6%) missing values	Missing
`case_type` has 35575 (29.5%) missing values	Missing
`cancelled_at` has 73418 (60.8%) missing values	Missing
`billable_item` has 18250 (15.1%) missing values	Missing
`category` has 24615 (20.4%) missing values	Missing
`concession_type` has 97703 (81.0%) missing values	Missing
`customer_type` has 77964 (64.6%) missing values	Missing
`title` has 53560 (44.4%) missing values	Missing
`state` has 58312 (48.3%) missing values	Missing
`sex` has 53523 (44.3%) missing values	Missing
`post_code` has 56784 (47.0%) missing values	Missing
`city` has 56373 (46.7%) missing values	Missing
`occupation` has 50304 (41.7%) missing values	Missing
`total_closed_invoices_before_appointemnt` has 80258 (66.5%) missing values	Missing
`total_open_invoices_before_appointemnt` is highly skewed (γ1 = 24.28150002)	Skewed
`post_code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_open_invoices_before_appointemnt` has 79567 (65.9%) zeros	Zeros
`total_good_appointments_before_cancelled_appointment` has 77555 (64.3%) zeros	Zeros
`total_cxl_appointments_before_cancelled_appointment` has 89930 (74.5%) zeros	Zeros
`percentage_good_appointments_and_missed_appointments_before_can` has 89930 (74.5%) zeros	Zeros
`notice` has 73418 (60.8%) zeros	Zeros
`session_left` has 13663 (11.3%) zeros	Zeros
`total_closed_invoices_before_appointemnt` has 10447 (8.7%) zeros	Zeros

Reproduction

Analysis started	2024-05-30 06:09:29.633640
Analysis finished	2024-05-30 06:10:49.190157
Duration	1 minute and 19.56 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

opened_case_name
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	35575
Missing (%)	29.5%
Memory size	1.8 MiB

Opened	47331
Expired	23830
Closed	13956

Length

Max length	7
Median length	6
Mean length	6.2799676
Min length	6

Characters and Unicode

Total characters	534532
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Expired
2nd row	Expired
3rd row	Opened
4th row	Expired
5th row	Opened

Common Values

Value	Count	Frequency (%)
Opened	47331	39.2%
Expired	23830	19.7%
Closed	13956	11.6%
(Missing)	35575	29.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
opened	47331	55.6%
expired	23830	28.0%
closed	13956	16.4%

Most occurring characters

Value	Count	Frequency (%)
e	132448	24.8%
d	85117	15.9%
p	71161	13.3%
O	47331	8.9%
n	47331	8.9%
E	23830	4.5%
x	23830	4.5%
i	23830	4.5%
r	23830	4.5%
C	13956	2.6%
Other values (3)	41868	7.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	534532	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	132448	24.8%
d	85117	15.9%
p	71161	13.3%
O	47331	8.9%
n	47331	8.9%
E	23830	4.5%
x	23830	4.5%
i	23830	4.5%
r	23830	4.5%
C	13956	2.6%
Other values (3)	41868	7.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	534532	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	132448	24.8%
d	85117	15.9%
p	71161	13.3%
O	47331	8.9%
n	47331	8.9%
E	23830	4.5%
x	23830	4.5%
i	23830	4.5%
r	23830	4.5%
C	13956	2.6%
Other values (3)	41868	7.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	534532	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	132448	24.8%
d	85117	15.9%
p	71161	13.3%
O	47331	8.9%
n	47331	8.9%
E	23830	4.5%
x	23830	4.5%
i	23830	4.5%
r	23830	4.5%
C	13956	2.6%
Other values (3)	41868	7.8%

total_open_invoices_before_appointemnt
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	40434
Missing (%)	33.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.014602906

Minimum	0
Maximum	11
Zeros	79567
Zeros (%)	65.9%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.20482016
Coefficient of variation (CV)	14.025987
Kurtosis	830.5179
Mean	0.014602906
Median Absolute Deviation (MAD)	0
Skewness	24.2815
Sum	1172
Variance	0.041951299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	79567	65.9%
1	464	0.4%
2	120	0.1%
3	46	< 0.1%
4	33	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	5	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
(Missing)	40434	33.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	79567	65.9%
1	464	0.4%
2	120	0.1%
3	46	< 0.1%
4	33	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	5	< 0.1%
8	4	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
11	3	< 0.1%
9	3	< 0.1%
8	4	< 0.1%
7	5	< 0.1%
6	6	< 0.1%
5	7	< 0.1%
4	33	< 0.1%
3	46	< 0.1%
2	120	0.1%
1	464	0.4%

total_good_appointments_before_cancelled_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	169
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5.2793083

Minimum	0
Maximum	295
Zeros	77555
Zeros (%)	64.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	26
Maximum	295
Range	295
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	16.78981
Coefficient of variation (CV)	3.1803048
Kurtosis	74.334661
Mean	5.2793083
Median Absolute Deviation (MAD)	0
Skewness	7.2611588
Sum	637165
Variance	281.89771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	77555	64.3%
2	4898	4.1%
1	4656	3.9%
3	4097	3.4%
4	3435	2.8%
5	2901	2.4%
6	2272	1.9%
7	1725	1.4%
8	1587	1.3%
9	1399	1.2%
Other values (159)	16166	13.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	77555	64.3%
1	4656	3.9%
2	4898	4.1%
3	4097	3.4%
4	3435	2.8%
5	2901	2.4%
6	2272	1.9%
7	1725	1.4%
8	1587	1.3%
9	1399	1.2%

Value	Count	Frequency (%)
295	4	< 0.1%
294	4	< 0.1%
288	4	< 0.1%
286	8	< 0.1%
278	4	< 0.1%
271	4	< 0.1%
270	4	< 0.1%
267	4	< 0.1%
264	8	< 0.1%
261	4	< 0.1%

total_cxl_appointments_before_cancelled_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	110
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1101481

Minimum	0
Maximum	144
Zeros	89930
Zeros (%)	74.5%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	11
Maximum	144
Range	144
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.8406378
Coefficient of variation (CV)	3.7156812
Kurtosis	75.060122
Mean	2.1101481
Median Absolute Deviation (MAD)	0
Skewness	7.4665406
Sum	254678
Variance	61.4756
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	89930	74.5%
1	7858	6.5%
2	4584	3.8%
3	3048	2.5%
4	2287	1.9%
5	1822	1.5%
6	1490	1.2%
7	1009	0.8%
10	920	0.8%
8	872	0.7%
Other values (100)	6872	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	89930	74.5%
1	7858	6.5%
2	4584	3.8%
3	3048	2.5%
4	2287	1.9%
5	1822	1.5%
6	1490	1.2%
7	1009	0.8%
8	872	0.7%
9	763	0.6%

Value	Count	Frequency (%)
144	4	< 0.1%
143	4	< 0.1%
137	4	< 0.1%
136	4	< 0.1%
134	4	< 0.1%
131	4	< 0.1%
126	8	< 0.1%
123	12	< 0.1%
118	4	< 0.1%
116	4	< 0.1%

percentage_good_appointments_and_missed_appointments_before_can
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	843
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2074556

Minimum	0
Maximum	100
Zeros	89930
Zeros (%)	74.5%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4.8387097
95-th percentile	57.142857
Maximum	100
Range	100
Interquartile range (IQR)	4.8387097

Descriptive statistics

Standard deviation	20.531745
Coefficient of variation (CV)	2.2299043
Kurtosis	6.8826289
Mean	9.2074556
Median Absolute Deviation (MAD)	0
Skewness	2.659494
Sum	1111266.2
Variance	421.55254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	89930	74.5%
33.33333333	1749	1.4%
50	1726	1.4%
100	1604	1.3%
25	1579	1.3%
20	1228	1.0%
16.66666667	911	0.8%
14.28571429	790	0.7%
11.11111111	649	0.5%
12.5	616	0.5%
Other values (833)	19910	16.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	89930	74.5%
1.612903226	12	< 0.1%
1.724137931	20	< 0.1%
1.754385965	2	< 0.1%
1.960784314	2	< 0.1%
2.083333333	2	< 0.1%
2.127659574	4	< 0.1%
2.173913043	1	< 0.1%
2.380952381	7	< 0.1%
2.43902439	9	< 0.1%

Value	Count	Frequency (%)
100	1604	1.3%
95.45454545	21	< 0.1%
95.23809524	20	< 0.1%
93.33333333	28	< 0.1%
92.30769231	48	< 0.1%
91.89189189	34	< 0.1%
91.66666667	33	< 0.1%
91.52542373	54	< 0.1%
91.30434783	21	< 0.1%
90.90909091	51	< 0.1%

patient_status
Categorical

IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Not Yet Actioned	114338
Therapist Follow Up	3223
Has An Upcoming Booking	1504
Patient Stopped Treatment	892
Admin Follow Up	400
Other values (5)	335

Length

Max length	25
Median length	16
Mean length	16.237033
Min length	14

Characters and Unicode

Total characters	1959680
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Yet Actioned
2nd row	Not Yet Actioned
3rd row	Not Yet Actioned
4th row	Not Yet Actioned
5th row	Admin Follow Up

Common Values

Value	Count	Frequency (%)
Not Yet Actioned	114338	94.7%
Therapist Follow Up	3223	2.7%
Has An Upcoming Booking	1504	1.2%
Patient Stopped Treatment	892	0.7%
Admin Follow Up	400	0.3%
On Waiting List	114	0.1%
Discharged By Therapist	111	0.1%
Do Not Contact	44	< 0.1%
Contacted Too Many Times	34	< 0.1%
Staff & Family	32	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	114382	31.5%
actioned	114338	31.4%
yet	114338	31.4%
follow	3623	1.0%
up	3623	1.0%
therapist	3334	0.9%
has	1504	0.4%
an	1504	0.4%
upcoming	1504	0.4%
booking	1504	0.4%
Other values (18)	3960	1.1%

Most occurring characters

Value	Count	Frequency (%)
t	351268	17.9%
	242922	12.4%
o	241560	12.3%
e	235757	12.0%
i	122491	6.3%
n	121374	6.2%
A	116242	5.9%
c	116031	5.9%
d	115775	5.9%
N	114382	5.8%
Other values (27)	181878	9.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1959680	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	351268	17.9%
	242922	12.4%
o	241560	12.3%
e	235757	12.0%
i	122491	6.3%
n	121374	6.2%
A	116242	5.9%
c	116031	5.9%
d	115775	5.9%
N	114382	5.8%
Other values (27)	181878	9.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1959680	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	351268	17.9%
	242922	12.4%
o	241560	12.3%
e	235757	12.0%
i	122491	6.3%
n	121374	6.2%
A	116242	5.9%
c	116031	5.9%
d	115775	5.9%
N	114382	5.8%
Other values (27)	181878	9.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1959680	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	351268	17.9%
	242922	12.4%
o	241560	12.3%
e	235757	12.0%
i	122491	6.3%
n	121374	6.2%
A	116242	5.9%
c	116031	5.9%
d	115775	5.9%
N	114382	5.8%
Other values (27)	181878	9.3%

patient_type
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

New To Clinic	77567
Recurring	38369
new to therapist	2304
new injury/issue	1967
new to service	485

Length

Max length	16
Median length	13
Mean length	11.838548
Min length	9

Characters and Unicode

Total characters	1428818
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Recurring
2nd row	New To Clinic
3rd row	Recurring
4th row	Recurring
5th row	Recurring

Common Values

Value	Count	Frequency (%)
New To Clinic	77567	64.3%
Recurring	38369	31.8%
new to therapist	2304	1.9%
new injury/issue	1967	1.6%
new to service	485	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
new	82323	29.1%
to	80356	28.4%
clinic	77567	27.4%
recurring	38369	13.5%
therapist	2304	0.8%
injury/issue	1967	0.7%
service	485	0.2%

Most occurring characters

Value	Count	Frequency (%)
i	200226	14.0%
	162679	11.4%
e	125933	8.8%
n	122659	8.6%
c	116421	8.1%
w	82323	5.8%
r	81494	5.7%
o	80356	5.6%
N	77567	5.4%
T	77567	5.4%
Other values (14)	301593	21.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1428818	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	200226	14.0%
	162679	11.4%
e	125933	8.8%
n	122659	8.6%
c	116421	8.1%
w	82323	5.8%
r	81494	5.7%
o	80356	5.6%
N	77567	5.4%
T	77567	5.4%
Other values (14)	301593	21.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1428818	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	200226	14.0%
	162679	11.4%
e	125933	8.8%
n	122659	8.6%
c	116421	8.1%
w	82323	5.8%
r	81494	5.7%
o	80356	5.6%
N	77567	5.4%
T	77567	5.4%
Other values (14)	301593	21.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1428818	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	200226	14.0%
	162679	11.4%
e	125933	8.8%
n	122659	8.6%
c	116421	8.1%
w	82323	5.8%
r	81494	5.7%
o	80356	5.6%
N	77567	5.4%
T	77567	5.4%
Other values (14)	301593	21.1%

time_of_day
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Afternoon	57831
Morning	55857
Evening	7004

Length

Max length	9
Median length	7
Mean length	7.9583237
Min length	7

Characters and Unicode

Total characters	960506
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Morning
2nd row	Morning
3rd row	Afternoon
4th row	Afternoon
5th row	Morning

Common Values

Value	Count	Frequency (%)
Afternoon	57831	47.9%
Morning	55857	46.3%
Evening	7004	5.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
afternoon	57831	47.9%
morning	55857	46.3%
evening	7004	5.8%

Most occurring characters

Value	Count	Frequency (%)
n	241384	25.1%
o	171519	17.9%
r	113688	11.8%
e	64835	6.8%
i	62861	6.5%
g	62861	6.5%
A	57831	6.0%
f	57831	6.0%
t	57831	6.0%
M	55857	5.8%
Other values (2)	14008	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	960506	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	241384	25.1%
o	171519	17.9%
r	113688	11.8%
e	64835	6.8%
i	62861	6.5%
g	62861	6.5%
A	57831	6.0%
f	57831	6.0%
t	57831	6.0%
M	55857	5.8%
Other values (2)	14008	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	960506	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	241384	25.1%
o	171519	17.9%
r	113688	11.8%
e	64835	6.8%
i	62861	6.5%
g	62861	6.5%
A	57831	6.0%
f	57831	6.0%
t	57831	6.0%
M	55857	5.8%
Other values (2)	14008	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	960506	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	241384	25.1%
o	171519	17.9%
r	113688	11.8%
e	64835	6.8%
i	62861	6.5%
g	62861	6.5%
A	57831	6.0%
f	57831	6.0%
t	57831	6.0%
M	55857	5.8%
Other values (2)	14008	1.5%

day_of_week
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	1.8 MiB

Thursday	25279
Tuesday	24118
Wednesday	23033
Monday	20414
Friday	20266
Other values (2)	7580

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1086210
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Tuesday
2nd row	Thursday
3rd row	Friday
4th row	Friday
5th row	Monday

Common Values

Value	Count	Frequency (%)
Thursday	25279	20.9%
Tuesday	24118	20.0%
Wednesday	23033	19.1%
Monday	20414	16.9%
Friday	20266	16.8%
Saturday	7514	6.2%
Sunday	66	0.1%
(Missing)	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thursday	25279	20.9%
tuesday	24118	20.0%
wednesday	23033	19.1%
monday	20414	16.9%
friday	20266	16.8%
saturday	7514	6.2%
sunday	66	0.1%

Most occurring characters

Value	Count	Frequency (%)
	203267	18.7%
d	143723	13.2%
a	128204	11.8%
y	120690	11.1%
s	72430	6.7%
e	70184	6.5%
u	56977	5.2%
r	53059	4.9%
T	49397	4.5%
n	43513	4.0%
Other values (8)	144766	13.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	203267	18.7%
d	143723	13.2%
a	128204	11.8%
y	120690	11.1%
s	72430	6.7%
e	70184	6.5%
u	56977	5.2%
r	53059	4.9%
T	49397	4.5%
n	43513	4.0%
Other values (8)	144766	13.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	203267	18.7%
d	143723	13.2%
a	128204	11.8%
y	120690	11.1%
s	72430	6.7%
e	70184	6.5%
u	56977	5.2%
r	53059	4.9%
T	49397	4.5%
n	43513	4.0%
Other values (8)	144766	13.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	203267	18.7%
d	143723	13.2%
a	128204	11.8%
y	120690	11.1%
s	72430	6.7%
e	70184	6.5%
u	56977	5.2%
r	53059	4.9%
T	49397	4.5%
n	43513	4.0%
Other values (8)	144766	13.3%

month_of_year
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	1.8 MiB

May	12686
March	11880
November	11608
April	11227
February	11119
Other values (7)	62170

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1086210
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	November
2nd row	October
3rd row	October
4th row	October
5th row	March

Common Values

Value	Count	Frequency (%)
May	12686	10.5%
March	11880	9.8%
November	11608	9.6%
April	11227	9.3%
February	11119	9.2%
January	10627	8.8%
December	9992	8.3%
June	9277	7.7%
August	8500	7.0%
October	8455	7.0%
Other values (2)	15319	12.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
may	12686	10.5%
march	11880	9.8%
november	11608	9.6%
april	11227	9.3%
february	11119	9.2%
january	10627	8.8%
december	9992	8.3%
june	9277	7.7%
august	8500	7.0%
october	8455	7.0%
Other values (2)	15319	12.7%

Most occurring characters

Value	Count	Frequency (%)
	350992	32.3%
e	104192	9.6%
r	93410	8.6%
a	56939	5.2%
u	55959	5.2%
b	48557	4.5%
y	42368	3.9%
c	30327	2.8%
m	28983	2.7%
J	27840	2.6%
Other values (17)	246643	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	350992	32.3%
e	104192	9.6%
r	93410	8.6%
a	56939	5.2%
u	55959	5.2%
b	48557	4.5%
y	42368	3.9%
c	30327	2.8%
m	28983	2.7%
J	27840	2.6%
Other values (17)	246643	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	350992	32.3%
e	104192	9.6%
r	93410	8.6%
a	56939	5.2%
u	55959	5.2%
b	48557	4.5%
y	42368	3.9%
c	30327	2.8%
m	28983	2.7%
J	27840	2.6%
Other values (17)	246643	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1086210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	350992	32.3%
e	104192	9.6%
r	93410	8.6%
a	56939	5.2%
u	55959	5.2%
b	48557	4.5%
y	42368	3.9%
c	30327	2.8%
m	28983	2.7%
J	27840	2.6%
Other values (17)	246643	22.7%

week_of_year
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	25.408427

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	23
Q3	39
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.283636
Coefficient of variation (CV)	0.60151839
Kurtosis	-1.250821
Mean	25.408427
Median Absolute Deviation (MAD)	13
Skewness	0.15891625
Sum	3066543
Variance	233.58953
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	2929	2.4%
21	2925	2.4%
45	2902	2.4%
51	2880	2.4%
9	2826	2.3%
12	2823	2.3%
50	2815	2.3%
19	2806	2.3%
46	2802	2.3%
2	2797	2.3%
Other values (43)	92185	76.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1778	1.5%
2	2797	2.3%
3	2596	2.2%
4	2292	1.9%
5	2749	2.3%
6	2711	2.2%
7	2517	2.1%
8	2763	2.3%
9	2826	2.3%
10	2743	2.3%

Value	Count	Frequency (%)
53	82	0.1%
52	868	0.7%
51	2880	2.4%
50	2815	2.3%
49	2649	2.2%
48	2715	2.2%
47	2652	2.2%
46	2802	2.3%
45	2902	2.4%
44	2079	1.7%

appointment_status
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Not Rebooked	89106
Rebooked	31586

Length

Max length	12
Median length	12
Mean length	10.95317
Min length	8

Characters and Unicode

Total characters	1321960
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Rebooked
2nd row	Not Rebooked
3rd row	Rebooked
4th row	Rebooked
5th row	Not Rebooked

Common Values

Value	Count	Frequency (%)
Not Rebooked	89106	73.8%
Rebooked	31586	26.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rebooked	120692	57.5%
not	89106	42.5%

Most occurring characters

Value	Count	Frequency (%)
o	330490	25.0%
e	241384	18.3%
R	120692	9.1%
b	120692	9.1%
k	120692	9.1%
d	120692	9.1%
N	89106	6.7%
t	89106	6.7%
	89106	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1321960	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	330490	25.0%
e	241384	18.3%
R	120692	9.1%
b	120692	9.1%
k	120692	9.1%
d	120692	9.1%
N	89106	6.7%
t	89106	6.7%
	89106	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1321960	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	330490	25.0%
e	241384	18.3%
R	120692	9.1%
b	120692	9.1%
k	120692	9.1%
d	120692	9.1%
N	89106	6.7%
t	89106	6.7%
	89106	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1321960	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	330490	25.0%
e	241384	18.3%
R	120692	9.1%
b	120692	9.1%
k	120692	9.1%
d	120692	9.1%
N	89106	6.7%
t	89106	6.7%
	89106	6.7%

notice
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	21560
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-942.49932

Minimum	-65869.135
Maximum	17186.203
Zeros	73418
Zeros (%)	60.8%
Negative	8585
Negative (%)	7.1%
Memory size	1.8 MiB

Quantile statistics

Minimum	-65869.135
5-th percentile	-5869.3219
Q1	0
median	0
Q3	9.1475694
95-th percentile	188.73361
Maximum	17186.203
Range	83055.338
Interquartile range (IQR)	9.1475694

Descriptive statistics

Standard deviation	5118.1669
Coefficient of variation (CV)	-5.4304197
Kurtosis	52.202731
Mean	-942.49932
Median Absolute Deviation (MAD)	0
Skewness	-6.3933856
Sum	-1.1375213 × 10⁸
Variance	26195633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73418	60.8%
25.56361111	16	< 0.1%
39.83416667	14	< 0.1%
1.076111111	14	< 0.1%
22.41583333	14	< 0.1%
42.14527778	14	< 0.1%
43.61527778	14	< 0.1%
22.88638889	14	< 0.1%
20.045	14	< 0.1%
1.436666667	14	< 0.1%
Other values (21550)	47146	39.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-65869.135	1	< 0.1%
-65863.135	1	< 0.1%
-65692.135	1	< 0.1%
-65578.635	1	< 0.1%
-65482.635	1	< 0.1%
-65476.135	1	< 0.1%
-65142.635	1	< 0.1%
-65020.635	1	< 0.1%
-64684.135	1	< 0.1%
-63829.135	1	< 0.1%

Value	Count	Frequency (%)
17186.20278	4	< 0.1%
16850.20278	4	< 0.1%
16514.20278	4	< 0.1%
16178.20278	4	< 0.1%
15842.20278	4	< 0.1%
15506.20278	4	< 0.1%
15170.20278	4	< 0.1%
14834.20306	4	< 0.1%
14498.20306	4	< 0.1%
14162.20306	4	< 0.1%

session_left
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	17
Distinct (%)	0.1%
Missing	93690
Missing (%)	77.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.5521443

Minimum	0
Maximum	28
Zeros	13663
Zeros (%)	11.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	6
Maximum	28
Range	28
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.3283571
Coefficient of variation (CV)	1.5000906
Kurtosis	10.286529
Mean	1.5521443
Median Absolute Deviation (MAD)	0
Skewness	2.409773
Sum	41911
Variance	5.4212467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	13663	11.3%
1	3831	3.2%
2	2692	2.2%
3	2576	2.1%
4	1746	1.4%
5	790	0.7%
6	419	0.3%
7	384	0.3%
8	254	0.2%
11	232	0.2%
Other values (7)	415	0.3%
(Missing)	93690	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13663	11.3%
1	3831	3.2%
2	2692	2.2%
3	2576	2.1%
4	1746	1.4%
5	790	0.7%
6	419	0.3%
7	384	0.3%
8	254	0.2%
9	224	0.2%

Value	Count	Frequency (%)
28	10	< 0.1%
23	2	< 0.1%
16	8	< 0.1%
13	16	< 0.1%
12	10	< 0.1%
11	232	0.2%
10	145	0.1%
9	224	0.2%
8	254	0.2%
7	384	0.3%

case_type
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	35575
Missing (%)	29.5%
Memory size	1.8 MiB

Unlimited	55087
Max Sessions	29826
Max Amount	204

Length

Max length	12
Median length	9
Mean length	10.053632
Min length	9

Characters and Unicode

Total characters	855735
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Unlimited
2nd row	Unlimited
3rd row	Unlimited
4th row	Unlimited
5th row	Unlimited

Common Values

Value	Count	Frequency (%)
Unlimited	55087	45.6%
Max Sessions	29826	24.7%
Max Amount	204	0.2%
(Missing)	35575	29.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
unlimited	55087	47.8%
max	30030	26.1%
sessions	29826	25.9%
amount	204	0.2%

Most occurring characters

Value	Count	Frequency (%)
i	140000	16.4%
s	89478	10.5%
n	85117	9.9%
e	84913	9.9%
m	55291	6.5%
t	55291	6.5%
U	55087	6.4%
l	55087	6.4%
d	55087	6.4%
	30030	3.5%
Other values (7)	150354	17.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	855735	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	140000	16.4%
s	89478	10.5%
n	85117	9.9%
e	84913	9.9%
m	55291	6.5%
t	55291	6.5%
U	55087	6.4%
l	55087	6.4%
d	55087	6.4%
	30030	3.5%
Other values (7)	150354	17.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	855735	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	140000	16.4%
s	89478	10.5%
n	85117	9.9%
e	84913	9.9%
m	55291	6.5%
t	55291	6.5%
U	55087	6.4%
l	55087	6.4%
d	55087	6.4%
	30030	3.5%
Other values (7)	150354	17.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	855735	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	140000	16.4%
s	89478	10.5%
n	85117	9.9%
e	84913	9.9%
m	55291	6.5%
t	55291	6.5%
U	55087	6.4%
l	55087	6.4%
d	55087	6.4%
	30030	3.5%
Other values (7)	150354	17.6%

cancelled_at
Date

MISSING

Distinct	14962
Distinct (%)	31.6%
Missing	73418
Missing (%)	60.8%
Memory size	1.8 MiB

Minimum	2020-07-16 08:36:13+00:00
Maximum	2024-05-28 08:47:23+00:00

Histogram

Histogram with fixed size bins (bins=50)

appointment_type
Text

Distinct	444
Distinct (%)	0.4%
Missing	61
Missing (%)	0.1%
Memory size	1.8 MiB

Length

Max length	106
Median length	87
Mean length	47.577563
Min length	4

Characters and Unicode

Total characters	5739329
Distinct characters	86
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	< 0.1%

Sample

1st row	2. Physiotherapy - 30 Minute Follow Up Consult
2nd row	1. ⭐️ Physiotherapy - 45 Minute Initial Consult
3rd row	2. Physiotherapy - 30 Minute Follow Up Consult
4th row	2. Physiotherapy - 30 Minute Follow Up Consult
5th row	2. Physiotherapy - 30 Minute Follow Up Consult

Value	Count	Frequency (%)
	112374	13.0%
consult	51921	6.0%
subsequent	46188	5.3%
2	45668	5.3%
consultation	45595	5.3%
up	44162	5.1%
follow	44126	5.1%
minute	32630	3.8%
physiotherapy	29759	3.4%
osteopathy	23229	2.7%
Other values (331)	390279	45.1%

Most occurring characters

Value	Count	Frequency (%)
	747808	13.0%
t	459919	8.0%
o	409890	7.1%
n	357066	6.2%
e	351873	6.1%
s	314104	5.5%
i	296746	5.2%
l	249052	4.3%
u	242829	4.2%
a	201012	3.5%
Other values (76)	2109030	36.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5739329	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	747808	13.0%
t	459919	8.0%
o	409890	7.1%
n	357066	6.2%
e	351873	6.1%
s	314104	5.5%
i	296746	5.2%
l	249052	4.3%
u	242829	4.2%
a	201012	3.5%
Other values (76)	2109030	36.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5739329	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	747808	13.0%
t	459919	8.0%
o	409890	7.1%
n	357066	6.2%
e	351873	6.1%
s	314104	5.5%
i	296746	5.2%
l	249052	4.3%
u	242829	4.2%
a	201012	3.5%
Other values (76)	2109030	36.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5739329	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	747808	13.0%
t	459919	8.0%
o	409890	7.1%
n	357066	6.2%
e	351873	6.1%
s	314104	5.5%
i	296746	5.2%
l	249052	4.3%
u	242829	4.2%
a	201012	3.5%
Other values (76)	2109030	36.7%

billable_item
Text

MISSING

Distinct	348
Distinct (%)	0.3%
Missing	18250
Missing (%)	15.1%
Memory size	1.8 MiB

Length

Max length	115
Median length	89
Mean length	46.591915
Min length	11

Characters and Unicode

Total characters	4772969
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	< 0.1%

Sample

1st row	Physiotherapy - 30 Minute Follow Up Consult
2nd row	Physiotherapy - 45 Minute Initial Consult
3rd row	Physiotherapy - 30 Minute Follow Up Consult
4th row	Physiotherapy - 30 Minute Follow Up Consult
5th row	Physiotherapy - 30 Minute Follow Up Consult

Value	Count	Frequency (%)
	96129	14.4%
consult	51612	7.7%
subsequent	46927	7.0%
consultation	45101	6.8%
up	42973	6.4%
follow	42910	6.4%
osteopathy	36693	5.5%
minute	32137	4.8%
physiotherapy	29100	4.4%
30	22594	3.4%
Other values (249)	220086	33.0%

Most occurring characters

Value	Count	Frequency (%)
	579642	12.1%
t	392528	8.2%
o	373034	7.8%
n	306944	6.4%
e	295966	6.2%
s	282801	5.9%
i	260542	5.5%
l	246385	5.2%
u	243169	5.1%
a	197942	4.1%
Other values (60)	1594016	33.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4772969	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	579642	12.1%
t	392528	8.2%
o	373034	7.8%
n	306944	6.4%
e	295966	6.2%
s	282801	5.9%
i	260542	5.5%
l	246385	5.2%
u	243169	5.1%
a	197942	4.1%
Other values (60)	1594016	33.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4772969	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	579642	12.1%
t	392528	8.2%
o	373034	7.8%
n	306944	6.4%
e	295966	6.2%
s	282801	5.9%
i	260542	5.5%
l	246385	5.2%
u	243169	5.1%
a	197942	4.1%
Other values (60)	1594016	33.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4772969	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	579642	12.1%
t	392528	8.2%
o	373034	7.8%
n	306944	6.4%
e	295966	6.2%
s	282801	5.9%
i	260542	5.5%
l	246385	5.2%
u	243169	5.1%
a	197942	4.1%
Other values (60)	1594016	33.4%

category
Text

MISSING

Distinct	139
Distinct (%)	0.1%
Missing	24615
Missing (%)	20.4%
Memory size	1.8 MiB

Length

Max length	68
Median length	60
Mean length	33.025146
Min length	3

Characters and Unicode

Total characters	3172957
Distinct characters	90
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	A \| PHYSIOTHERAPY
2nd row	A \| PHYSIOTHERAPY
3rd row	A \| PHYSIOTHERAPY
4th row	A \| PHYSIOTHERAPY
5th row	A \| PHYSIOTHERAPY

Value	Count	Frequency (%)
	55387	11.6%
2	36191	7.5%
subsequent	30047	6.3%
consultations	29138	6.1%
for	28877	6.0%
osteopathy	28582	6.0%
existing	28464	5.9%
patients	28464	5.9%
physiotherapy	18041	3.8%
a	17257	3.6%
Other values (191)	178957	37.3%

Most occurring characters

Value	Count	Frequency (%)
	385066	12.1%
t	251135	7.9%
s	219566	6.9%
e	176794	5.6%
n	160850	5.1%
o	145076	4.6%
i	139802	4.4%
a	135318	4.3%
P	103035	3.2%
u	98842	3.1%
Other values (80)	1357473	42.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3172957	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	385066	12.1%
t	251135	7.9%
s	219566	6.9%
e	176794	5.6%
n	160850	5.1%
o	145076	4.6%
i	139802	4.4%
a	135318	4.3%
P	103035	3.2%
u	98842	3.1%
Other values (80)	1357473	42.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3172957	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	385066	12.1%
t	251135	7.9%
s	219566	6.9%
e	176794	5.6%
n	160850	5.1%
o	145076	4.6%
i	139802	4.4%
a	135318	4.3%
P	103035	3.2%
u	98842	3.1%
Other values (80)	1357473	42.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3172957	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	385066	12.1%
t	251135	7.9%
s	219566	6.9%
e	176794	5.6%
n	160850	5.1%
o	145076	4.6%
i	139802	4.4%
a	135318	4.3%
P	103035	3.2%
u	98842	3.1%
Other values (80)	1357473	42.8%

cancelled
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

False	73418
True	47274

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	73418	60.8%
True	47274	39.2%

appointment_start_time
Date

Distinct	47410
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Minimum	2009-07-28 22:45:00+00:00
Maximum	2025-12-23 00:45:00+00:00

Histogram

Histogram with fixed size bins (bins=50)

business_name
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Scarb Physio & Health	24911
Osteopathy \| Melton	23208
⬅️ Front Desk Migration	16650
Osteopathy \| Bacchus Marsh	15055
All Sorted Physiotherapy	9661
Other values (18)	31207

Length

Max length	30
Median length	26
Mean length	21.396141
Min length	12

Characters and Unicode

Total characters	2582343
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Scarb Physio & Health
2nd row	Scarb Physio & Health
3rd row	Scarb Physio & Health
4th row	Scarb Physio & Health
5th row	Scarb Physio & Health

Common Values

Value	Count	Frequency (%)
Scarb Physio & Health	24911	20.6%
Osteopathy \| Melton	23208	19.2%
⬅️ Front Desk Migration	16650	13.8%
Osteopathy \| Bacchus Marsh	15055	12.5%
All Sorted Physiotherapy	9661	8.0%
Newport Psychology	7289	6.0%
Scarb Remedial Massage	6753	5.6%
Newport Physiotherapy	6437	5.3%
Bosch Psychology	4511	3.7%
PhysioCall Gladstone	1842	1.5%
Other values (13)	4375	3.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	66509	16.7%
osteopathy	38263	9.6%
scarb	32403	8.1%
health	25400	6.4%
melton	25339	6.3%
physio	24911	6.2%
physiotherapy	17326	4.3%
⬅️	16650	4.2%
front	16650	4.2%
desk	16650	4.2%
Other values (25)	119029	29.8%

Most occurring characters

Value	Count	Frequency (%)
	278438	10.8%
t	203754	7.9%
o	197072	7.6%
a	189317	7.3%
h	173678	6.7%
e	171250	6.6%
s	167484	6.5%
y	124746	4.8%
r	122194	4.7%
l	96087	3.7%
Other values (37)	858323	33.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2582343	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	278438	10.8%
t	203754	7.9%
o	197072	7.6%
a	189317	7.3%
h	173678	6.7%
e	171250	6.6%
s	167484	6.5%
y	124746	4.8%
r	122194	4.7%
l	96087	3.7%
Other values (37)	858323	33.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2582343	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	278438	10.8%
t	203754	7.9%
o	197072	7.6%
a	189317	7.3%
h	173678	6.7%
e	171250	6.6%
s	167484	6.5%
y	124746	4.8%
r	122194	4.7%
l	96087	3.7%
Other values (37)	858323	33.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2582343	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	278438	10.8%
t	203754	7.9%
o	197072	7.6%
a	189317	7.3%
h	173678	6.7%
e	171250	6.6%
s	167484	6.5%
y	124746	4.8%
r	122194	4.7%
l	96087	3.7%
Other values (37)	858323	33.2%

concession_type
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	17
Distinct (%)	0.1%
Missing	97703
Missing (%)	81.0%
Memory size	1.8 MiB

Concession Discount	13652
Concession / Pension Card Holder	5724
VIP Discount	1867
Student	1294
VIP + Concession Discount	315
Other values (12)	137

Length

Max length	32
Median length	19
Mean length	21.06129
Min length	3

Characters and Unicode

Total characters	484178
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Concession / Pension Card Holder
2nd row	Concession / Pension Card Holder
3rd row	Concession / Pension Card Holder
4th row	Concession / Pension Card Holder
5th row	Concession / Pension Card Holder

Common Values

Value	Count	Frequency (%)
Concession Discount	13652	11.3%
Concession / Pension Card Holder	5724	4.7%
VIP Discount	1867	1.5%
Student	1294	1.1%
VIP + Concession Discount	315	0.3%
WorkCover	27	< 0.1%
Patient is under 18 years old	22	< 0.1%
Students \| Under 18 Years Old	19	< 0.1%
Medicare	16	< 0.1%
Third Party	13	< 0.1%
Other values (7)	40	< 0.1%
(Missing)	97703	81.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
concession	19708	31.5%
discount	15834	25.3%
	6065	9.7%
card	5734	9.2%
pension	5724	9.1%
holder	5724	9.1%
vip	2182	3.5%
student	1294	2.1%
under	41	0.1%
old	41	0.1%
Other values (15)	254	0.4%

Most occurring characters

Value	Count	Frequency (%)
n	68120	14.1%
o	66809	13.8%
s	61102	12.6%
i	41361	8.5%
	39612	8.2%
c	35561	7.3%
e	32685	6.8%
C	25472	5.3%
t	18521	3.8%
u	17171	3.5%
Other values (27)	77764	16.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	484178	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	68120	14.1%
o	66809	13.8%
s	61102	12.6%
i	41361	8.5%
	39612	8.2%
c	35561	7.3%
e	32685	6.8%
C	25472	5.3%
t	18521	3.8%
u	17171	3.5%
Other values (27)	77764	16.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	484178	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	68120	14.1%
o	66809	13.8%
s	61102	12.6%
i	41361	8.5%
	39612	8.2%
c	35561	7.3%
e	32685	6.8%
C	25472	5.3%
t	18521	3.8%
u	17171	3.5%
Other values (27)	77764	16.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	484178	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	68120	14.1%
o	66809	13.8%
s	61102	12.6%
i	41361	8.5%
	39612	8.2%
c	35561	7.3%
e	32685	6.8%
C	25472	5.3%
t	18521	3.8%
u	17171	3.5%
Other values (27)	77764	16.1%

customer_type
Categorical

HIGH CORRELATION MISSING

Distinct	32
Distinct (%)	0.1%
Missing	77964
Missing (%)	64.6%
Memory size	1.8 MiB

WorkCover	6918
Medicare Referrals	5887
NDIS	4528
CDM	4438
Concession / Pension Card Holder	4330
Other values (27)	16627

Length

Max length	32
Median length	29
Mean length	11.55968
Min length	3

Characters and Unicode

Total characters	493922
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Concession / Pension Card Holder
2nd row	Concession / Pension Card Holder
3rd row	Concession / Pension Card Holder
4th row	Concession / Pension Card Holder
5th row	Concession / Pension Card Holder

Common Values

Value	Count	Frequency (%)
WorkCover	6918	5.7%
Medicare Referrals	5887	4.9%
NDIS	4528	3.8%
CDM	4438	3.7%
Concession / Pension Card Holder	4330	3.6%
DVA	4191	3.5%
DVA Card Holder	2891	2.4%
Medicare	1883	1.6%
NDIS Customer	1489	1.2%
Third Party	1445	1.2%
Other values (22)	4728	3.9%
(Missing)	77964	64.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
medicare	7770	9.8%
card	7225	9.1%
holder	7221	9.1%
dva	7082	8.9%
workcover	6952	8.8%
ndis	6017	7.6%
referrals	5887	7.4%
	5122	6.4%
cdm	4438	5.6%
concession	4341	5.5%
Other values (34)	17386	21.9%

Most occurring characters

Value	Count	Frequency (%)
e	56373	11.4%
r	55221	11.2%
	37307	7.6%
o	36908	7.5%
d	26129	5.3%
C	25948	5.3%
a	25190	5.1%
s	21736	4.4%
i	20049	4.1%
n	19815	4.0%
Other values (36)	169246	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	493922	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	56373	11.4%
r	55221	11.2%
	37307	7.6%
o	36908	7.5%
d	26129	5.3%
C	25948	5.3%
a	25190	5.1%
s	21736	4.4%
i	20049	4.1%
n	19815	4.0%
Other values (36)	169246	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	493922	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	56373	11.4%
r	55221	11.2%
	37307	7.6%
o	36908	7.5%
d	26129	5.3%
C	25948	5.3%
a	25190	5.1%
s	21736	4.4%
i	20049	4.1%
n	19815	4.0%
Other values (36)	169246	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	493922	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	56373	11.4%
r	55221	11.2%
	37307	7.6%
o	36908	7.5%
d	26129	5.3%
C	25948	5.3%
a	25190	5.1%
s	21736	4.4%
i	20049	4.1%
n	19815	4.0%
Other values (36)	169246	34.3%

title
Categorical

IMBALANCE MISSING

Distinct	28
Distinct (%)	< 0.1%
Missing	53560
Missing (%)	44.4%
Memory size	1.8 MiB

Mr	22269
Mrs	18159
Ms	14851
Miss	7712
	1818
Other values (23)	2323

Length

Max length	15
Median length	2
Mean length	2.5545046
Min length	1

Characters and Unicode

Total characters	171489
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Mrs
2nd row	Mrs
3rd row	Mr
4th row	Mr
5th row	Mr

Common Values

Value	Count	Frequency (%)
Mr	22269	18.5%
Mrs	18159	15.0%
Ms	14851	12.3%
Miss	7712	6.4%
	1818	1.5%
Master	956	0.8%
Dr	616	0.5%
MISS	291	0.2%
Mrs	128	0.1%
Mr	112	0.1%
Other values (18)	220	0.2%
(Missing)	53560	44.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mr	22414	34.3%
mrs	18289	28.0%
ms	14884	22.8%
miss	8004	12.3%
master	1057	1.6%
dr	616	0.9%
sr	12	< 0.1%
no	10	< 0.1%
title	10	< 0.1%
please	10	< 0.1%
Other values (5)	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	64656	37.7%
s	49575	28.9%
r	42281	24.7%
i	7724	4.5%
	2227	1.3%
e	994	0.6%
t	983	0.6%
a	974	0.6%
S	697	0.4%
D	616	0.4%
Other values (16)	762	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	171489	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	64656	37.7%
s	49575	28.9%
r	42281	24.7%
i	7724	4.5%
	2227	1.3%
e	994	0.6%
t	983	0.6%
a	974	0.6%
S	697	0.4%
D	616	0.4%
Other values (16)	762	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	171489	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	64656	37.7%
s	49575	28.9%
r	42281	24.7%
i	7724	4.5%
	2227	1.3%
e	994	0.6%
t	983	0.6%
a	974	0.6%
S	697	0.4%
D	616	0.4%
Other values (16)	762	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	171489	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	64656	37.7%
s	49575	28.9%
r	42281	24.7%
i	7724	4.5%
	2227	1.3%
e	994	0.6%
t	983	0.6%
a	974	0.6%
S	697	0.4%
D	616	0.4%
Other values (16)	762	0.4%

state
Categorical

IMBALANCE MISSING

Distinct	27
Distinct (%)	< 0.1%
Missing	58312
Missing (%)	48.3%
Memory size	1.8 MiB

QLD	54693
VIC	3541
Qld	2269
Vic	576
NSW	487
Other values (22)	814

Length

Max length	13
Median length	3
Mean length	3.0088971
Min length	2

Characters and Unicode

Total characters	187695
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	QLD
2nd row	QLD
3rd row	QLD
4th row	QLD
5th row	QLD

Common Values

Value	Count	Frequency (%)
QLD	54693	45.3%
VIC	3541	2.9%
Qld	2269	1.9%
Vic	576	0.5%
NSW	487	0.4%
QLD	292	0.2%
VIc	158	0.1%
VIC	105	0.1%
VIC	58	< 0.1%
Qld	57	< 0.1%
Other values (17)	144	0.1%
(Missing)	58312	48.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
qld	57346	91.9%
vic	4488	7.2%
nsw	487	0.8%
wa	25	< 0.1%
act	9	< 0.1%
sa	8	< 0.1%
melton	4	< 0.1%
nt	3	< 0.1%
viv	3	< 0.1%
west	3	< 0.1%
Other values (7)	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
Q	57313	30.5%
L	54987	29.3%
D	54985	29.3%
V	4446	2.4%
I	3865	2.1%
C	3713	2.0%
l	2366	1.3%
d	2365	1.3%
c	784	0.4%
i	628	0.3%
Other values (28)	2243	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	187695	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	57313	30.5%
L	54987	29.3%
D	54985	29.3%
V	4446	2.4%
I	3865	2.1%
C	3713	2.0%
l	2366	1.3%
d	2365	1.3%
c	784	0.4%
i	628	0.3%
Other values (28)	2243	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	187695	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	57313	30.5%
L	54987	29.3%
D	54985	29.3%
V	4446	2.4%
I	3865	2.1%
C	3713	2.0%
l	2366	1.3%
d	2365	1.3%
c	784	0.4%
i	628	0.3%
Other values (28)	2243	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	187695	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	57313	30.5%
L	54987	29.3%
D	54985	29.3%
V	4446	2.4%
I	3865	2.1%
C	3713	2.0%
l	2366	1.3%
d	2365	1.3%
c	784	0.4%
i	628	0.3%
Other values (28)	2243	1.2%

date_of_birth
Date

Distinct	14588
Distinct (%)	12.2%
Missing	925
Missing (%)	0.8%
Memory size	1.8 MiB

Minimum	1909-01-31 00:00:00
Maximum	2024-04-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

sex
Categorical

IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	53523
Missing (%)	44.3%
Memory size	1.8 MiB

Female	44050
Male	22826
female	186
male	81
AMAB	22

Length

Max length	6
Median length	6
Mean length	5.3172148
Min length	4

Characters and Unicode

Total characters	357152
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Male
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	44050	36.5%
Male	22826	18.9%
female	186	0.2%
male	81	0.1%
AMAB	22	< 0.1%
Other	4	< 0.1%
(Missing)	53523	44.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	44236	65.9%
male	22907	34.1%
amab	22	< 0.1%
other	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	111383	31.2%
a	67143	18.8%
l	67143	18.8%
m	44317	12.4%
F	44050	12.3%
M	22848	6.4%
f	186	0.1%
A	44	< 0.1%
B	22	< 0.1%
O	4	< 0.1%
Other values (3)	12	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	357152	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	111383	31.2%
a	67143	18.8%
l	67143	18.8%
m	44317	12.4%
F	44050	12.3%
M	22848	6.4%
f	186	0.1%
A	44	< 0.1%
B	22	< 0.1%
O	4	< 0.1%
Other values (3)	12	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	357152	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	111383	31.2%
a	67143	18.8%
l	67143	18.8%
m	44317	12.4%
F	44050	12.3%
M	22848	6.4%
f	186	0.1%
A	44	< 0.1%
B	22	< 0.1%
O	4	< 0.1%
Other values (3)	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	357152	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	111383	31.2%
a	67143	18.8%
l	67143	18.8%
m	44317	12.4%
F	44050	12.3%
M	22848	6.4%
f	186	0.1%
A	44	< 0.1%
B	22	< 0.1%
O	4	< 0.1%
Other values (3)	12	< 0.1%

post_code
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	56784
Missing (%)	47.0%
Memory size	1.8 MiB

city
Text

MISSING

Distinct	633
Distinct (%)	1.0%
Missing	56373
Missing (%)	46.7%
Memory size	1.8 MiB

Length

Max length	27
Median length	21
Mean length	9.4763756
Min length	2

Characters and Unicode

Total characters	609511
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	151 ?
Unique (%)	0.2%

Sample

1st row	KIPPA RING
2nd row	KIPPA RING
3rd row	Scarborough
4th row	Scarborough
5th row	Scarborough

Value	Count	Frequency (%)
scarborough	14138	18.3%
newport	8383	10.8%
redcliffe	6613	8.5%
gladstone	4965	6.4%
margate	3067	4.0%
bay	2702	3.5%
deception	2686	3.5%
clontarf	2641	3.4%
kippa	2180	2.8%
ring	2180	2.8%
Other values (430)	27901	36.0%

Most occurring characters

Value	Count	Frequency (%)
o	52609	8.6%
r	46177	7.6%
e	38746	6.4%
a	37660	6.2%
t	23336	3.8%
c	23088	3.8%
g	21967	3.6%
S	21263	3.5%
i	20719	3.4%
l	20062	3.3%
Other values (58)	303884	49.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	609511	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	52609	8.6%
r	46177	7.6%
e	38746	6.4%
a	37660	6.2%
t	23336	3.8%
c	23088	3.8%
g	21967	3.6%
S	21263	3.5%
i	20719	3.4%
l	20062	3.3%
Other values (58)	303884	49.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	609511	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	52609	8.6%
r	46177	7.6%
e	38746	6.4%
a	37660	6.2%
t	23336	3.8%
c	23088	3.8%
g	21967	3.6%
S	21263	3.5%
i	20719	3.4%
l	20062	3.3%
Other values (58)	303884	49.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	609511	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	52609	8.6%
r	46177	7.6%
e	38746	6.4%
a	37660	6.2%
t	23336	3.8%
c	23088	3.8%
g	21967	3.6%
S	21263	3.5%
i	20719	3.4%
l	20062	3.3%
Other values (58)	303884	49.9%

occupation
Text

MISSING

Distinct	3136
Distinct (%)	4.5%
Missing	50304
Missing (%)	41.7%
Memory size	1.8 MiB

Length

Max length	56
Median length	44
Mean length	12.023754
Min length	1

Characters and Unicode

Total characters	846328
Distinct characters	77
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	437 ?
Unique (%)	0.6%

Sample

1st row	Retired
2nd row	Retired
3rd row	Draftsman
4th row	Draftsman
5th row	Draftsman

Value	Count	Frequency (%)
retired	13366	11.8%
manager	4049	3.6%
student	3974	3.5%
teacher	3405	3.0%
worker	3295	2.9%
nurse	2311	2.0%
support	2134	1.9%
officer	2106	1.9%
assistant	1929	1.7%
driver	1792	1.6%
Other values (1768)	74870	66.1%

Most occurring characters

Value	Count	Frequency (%)
e	113390	13.4%
r	84824	10.0%
t	68858	8.1%
i	64207	7.6%
a	51824	6.1%
n	46908	5.5%
	43876	5.2%
o	38416	4.5%
s	35944	4.2%
d	32063	3.8%
Other values (67)	266018	31.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	846328	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	113390	13.4%
r	84824	10.0%
t	68858	8.1%
i	64207	7.6%
a	51824	6.1%
n	46908	5.5%
	43876	5.2%
o	38416	4.5%
s	35944	4.2%
d	32063	3.8%
Other values (67)	266018	31.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	846328	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	113390	13.4%
r	84824	10.0%
t	68858	8.1%
i	64207	7.6%
a	51824	6.1%
n	46908	5.5%
	43876	5.2%
o	38416	4.5%
s	35944	4.2%
d	32063	3.8%
Other values (67)	266018	31.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	846328	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	113390	13.4%
r	84824	10.0%
t	68858	8.1%
i	64207	7.6%
a	51824	6.1%
n	46908	5.5%
	43876	5.2%
o	38416	4.5%
s	35944	4.2%
d	32063	3.8%
Other values (67)	266018	31.4%

referred
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

False	80292
True	40400

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	80292	66.5%
True	40400	33.5%

total_closed_invoices_before_appointemnt
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	174
Distinct (%)	0.4%
Missing	80258
Missing (%)	66.5%
Infinite	0
Infinite (%)	0.0%
Mean	12.050354

Minimum	0
Maximum	305
Zeros	10447
Zeros (%)	8.7%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	12
95-th percentile	58
Maximum	305
Range	305
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	25.594842
Coefficient of variation (CV)	2.1239909
Kurtosis	34.544534
Mean	12.050354
Median Absolute Deviation (MAD)	3
Skewness	5.0288834
Sum	487244
Variance	655.09592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10447	8.7%
1	3817	3.2%
2	3279	2.7%
3	2916	2.4%
4	2114	1.8%
5	1751	1.5%
6	1379	1.1%
7	1062	0.9%
8	1048	0.9%
9	978	0.8%
Other values (164)	11643	9.6%
(Missing)	80258	66.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10447	8.7%
1	3817	3.2%
2	3279	2.7%
3	2916	2.4%
4	2114	1.8%
5	1751	1.5%
6	1379	1.1%
7	1062	0.9%
8	1048	0.9%
9	978	0.8%

Value	Count	Frequency (%)
305	4	< 0.1%
303	4	< 0.1%
297	4	< 0.1%
295	4	< 0.1%
294	4	< 0.1%
286	4	< 0.1%
280	4	< 0.1%
278	4	< 0.1%
275	4	< 0.1%
273	4	< 0.1%

Auto

Heatmap
Table

	appointment_status	business_name	cancelled	case_type	concession_type	customer_type	day_of_week	month_of_year	notice	opened_case_name	patient_status	patient_type	percentage_good_appointments_and_missed_appointments_before_can	referred	session_left	sex	state	time_of_day	title	total_closed_invoices_before_appointemnt	total_cxl_appointments_before_cancelled_appointment	total_good_appointments_before_cancelled_appointment	total_open_invoices_before_appointemnt	week_of_year
appointment_status	1.000	0.508	0.742	0.043	0.398	0.333	0.059	0.052	0.406	0.166	0.160	0.728	0.604	0.104	0.008	0.065	0.181	0.086	0.153	0.077	0.626	0.731	0.342	-0.015
business_name	0.508	1.000	0.620	0.195	0.505	0.293	0.121	0.082	0.175	0.290	0.099	0.321	-0.216	0.794	-0.021	0.087	0.251	0.176	0.147	0.439	-0.194	-0.119	-0.054	0.010
cancelled	0.742	0.620	1.000	0.041	0.507	0.387	0.076	0.050	0.612	0.251	0.294	0.929	0.719	0.166	0.086	0.053	0.239	0.092	0.197	NaN	0.719	0.900	0.305	-0.033
case_type	0.043	0.195	0.041	1.000	0.104	0.272	0.071	0.024	0.000	0.519	0.026	0.045	-0.034	0.122	NaN	0.015	0.035	0.061	0.036	0.008	-0.031	-0.025	-0.012	-0.013
concession_type	0.398	0.505	0.507	0.104	1.000	0.651	0.075	0.054	-0.314	0.268	0.086	0.244	-0.250	0.800	0.001	0.087	0.318	0.157	0.191	-0.184	-0.253	-0.312	-0.001	0.000
customer_type	0.333	0.293	0.387	0.272	0.651	1.000	0.129	0.068	-0.047	0.267	0.090	0.201	0.009	0.543	0.085	0.239	0.268	0.188	0.203	0.071	0.021	-0.005	0.091	-0.016
day_of_week	0.059	0.121	0.076	0.071	0.075	0.129	1.000	0.033	0.027	0.054	0.037	0.046	0.008	0.115	-0.016	0.039	0.059	0.146	0.049	0.055	0.012	0.023	-0.022	-0.012
month_of_year	0.052	0.082	0.050	0.024	0.054	0.068	0.033	1.000	-0.040	0.050	0.055	0.048	0.003	0.078	0.002	0.013	0.045	0.020	0.030	-0.002	0.006	-0.022	-0.005	0.298
notice	0.406	0.175	0.612	0.000	-0.314	-0.047	0.027	-0.040	1.000	0.062	0.033	0.190	0.198	0.159	0.074	0.017	0.043	0.045	0.136	0.372	0.231	0.578	0.288	-0.044
opened_case_name	0.166	0.290	0.251	0.519	0.268	0.267	0.054	0.050	0.062	1.000	0.035	0.165	-0.140	0.236	0.899	0.029	0.144	0.077	0.077	-0.037	-0.143	-0.153	0.004	-0.015
patient_status	0.160	0.099	0.294	0.026	0.086	0.090	0.037	0.055	0.033	0.035	1.000	0.160	0.071	0.141	0.013	0.029	0.041	0.032	0.035	0.066	0.074	0.109	-0.034	-0.058
patient_type	0.728	0.321	0.929	0.045	0.244	0.201	0.046	0.048	0.190	0.165	0.160	1.000	0.691	0.182	0.075	0.035	0.106	0.068	0.095	0.195	0.708	0.953	0.312	-0.014
percentage_good_appointments_and_missed_appointments_before_can	0.604	-0.216	0.719	-0.034	-0.250	0.009	0.008	0.003	0.198	-0.140	0.071	0.691	1.000	0.154	0.062	0.046	0.071	0.058	0.113	-0.121	0.982	0.729	0.320	-0.001
referred	0.104	0.794	0.166	0.122	0.800	0.543	0.115	0.078	0.159	0.236	0.141	0.182	0.154	1.000	-0.018	0.058	0.329	0.156	0.271	0.276	0.078	0.167	0.051	0.007
session_left	0.008	-0.021	0.086	NaN	0.001	0.085	-0.016	0.002	0.074	0.899	0.013	0.075	0.062	-0.018	1.000	0.102	0.043	0.044	0.092	-0.115	0.048	0.045	0.073	-0.007
sex	0.065	0.087	0.053	0.015	0.087	0.239	0.039	0.013	0.017	0.029	0.029	0.035	0.046	0.058	0.102	1.000	0.101	0.021	0.495	0.015	-0.062	-0.037	0.043	0.010
state	0.181	0.251	0.239	0.035	0.318	0.268	0.059	0.045	0.043	0.144	0.041	0.106	0.071	0.329	0.043	0.101	1.000	0.096	0.074	-0.084	-0.165	-0.173	0.001	-0.032
time_of_day	0.086	0.176	0.092	0.061	0.157	0.188	0.146	0.020	0.045	0.077	0.032	0.068	0.058	0.156	0.044	0.021	0.096	1.000	0.077	0.097	0.030	0.048	0.015	0.002
title	0.153	0.147	0.197	0.036	0.191	0.203	0.049	0.030	0.136	0.077	0.035	0.095	0.113	0.271	0.092	0.495	0.074	0.077	1.000	0.063	0.105	0.114	-0.012	-0.028
total_closed_invoices_before_appointemnt	0.077	0.439	NaN	0.008	-0.184	0.071	0.055	-0.002	0.372	-0.037	0.066	0.195	-0.121	0.276	-0.115	0.015	-0.084	0.097	0.063	1.000	0.266	0.772	NaN	0.022
total_cxl_appointments_before_cancelled_appointment	0.626	-0.194	0.719	-0.031	-0.253	0.021	0.012	0.006	0.231	-0.143	0.074	0.708	0.982	0.078	0.048	-0.062	-0.165	0.030	0.105	0.266	1.000	0.780	0.324	0.005
total_good_appointments_before_cancelled_appointment	0.731	-0.119	0.900	-0.025	-0.312	-0.005	0.023	-0.022	0.578	-0.153	0.109	0.953	0.729	0.167	0.045	-0.037	-0.173	0.048	0.114	0.772	0.780	1.000	0.325	-0.013
total_open_invoices_before_appointemnt	0.342	-0.054	0.305	-0.012	-0.001	0.091	-0.022	-0.005	0.288	0.004	-0.034	0.312	0.320	0.051	0.073	0.043	0.001	0.015	-0.012	NaN	0.324	0.325	1.000	-0.008
week_of_year	-0.015	0.010	-0.033	-0.013	0.000	-0.016	-0.012	0.298	-0.044	-0.015	-0.058	-0.014	-0.001	0.007	-0.007	0.010	-0.032	0.002	-0.028	0.022	0.005	-0.013	-0.008	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	opened_case_name	total_good_appointments_before_cancelled_appointment	total_cxl_appointments_before_cancelled_appointment	percentage_good_appointments_and_missed_appointments_before_can	patient_status	patient_type	time_of_day	day_of_week	month_of_year	week_of_year	appointment_status	notice	session_left	case_type	cancelled_at	appointment_type	billable_item	category	cancelled	appointment_start_time	business_name	concession_type	customer_type	title	state	date_of_birth	sex	post_code	city	occupation	referred	total_closed_invoices_before_appointemnt
0	Expired	1.0	0	0.0	Not Yet Actioned	Recurring	Morning	Tuesday	November	46.0	Not Rebooked	2.054167	NaN	Unlimited	2022-11-14 22:26:45+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-11-15 00:30:00+00	Scarb Physio & Health	Concession / Pension Card Holder	Concession / Pension Card Holder	Mrs	QLD	1928-07-20	Female	4020.0	KIPPA RING	Retired	Yes	NaN
1	Expired	0.0	0	0.0	Not Yet Actioned	New To Clinic	Morning	Thursday	October	42.0	Not Rebooked	0.000000	NaN	Unlimited	NaN	1. ⭐️ Physiotherapy - 45 Minute Initial Consult	Physiotherapy - 45 Minute Initial Consult	A \| PHYSIOTHERAPY	No	2022-10-20 00:30:00+00	Scarb Physio & Health	Concession / Pension Card Holder	Concession / Pension Card Holder	Mrs	QLD	1928-07-20	Female	4020.0	KIPPA RING	Retired	Yes	NaN
2	Opened	8.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Friday	October	43.0	Rebooked	26.688333	NaN	Unlimited	2022-10-27 00:48:42+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-10-28 03:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
3	Expired	8.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Friday	October	43.0	Rebooked	26.688333	NaN	Unlimited	2022-10-27 00:48:42+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-10-28 03:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
5	Opened	9.0	1	10.0	Admin Follow Up	Recurring	Morning	Monday	March	13.0	Not Rebooked	1.770556	NaN	Unlimited	2024-03-24 21:43:46+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2024-03-24 23:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
6	Expired	9.0	1	10.0	Admin Follow Up	Recurring	Morning	Monday	March	13.0	Not Rebooked	1.770556	NaN	Unlimited	2024-03-24 21:43:46+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2024-03-24 23:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
8	Expired	0.0	0	0.0	Not Yet Actioned	New To Clinic	Morning	Monday	March	13.0	Not Rebooked	0.000000	NaN	Unlimited	NaN	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	No	2022-03-28 01:00:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
9	Opened	0.0	0	0.0	Not Yet Actioned	New To Clinic	Morning	Saturday	October	41.0	Not Rebooked	0.000000	NaN	Unlimited	NaN	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	No	2022-10-14 23:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
11	Expired	0.0	0	0.0	Not Yet Actioned	New To Clinic	Morning	Tuesday	April	15.0	Not Rebooked	0.000000	NaN	Unlimited	NaN	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	No	2022-04-11 21:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN
12	Expired	0.0	0	0.0	Not Yet Actioned	New To Clinic	Morning	Monday	March	12.0	Not Rebooked	0.000000	NaN	Unlimited	NaN	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	No	2022-03-21 00:30:00+00	Scarb Physio & Health	NaN	NaN	Mr	QLD	1956-06-19	Male	4020.0	Scarborough	Draftsman	Yes	NaN

	opened_case_name	total_open_invoices_before_appointemnt	total_good_appointments_before_cancelled_appointment	total_cxl_appointments_before_cancelled_appointment	percentage_good_appointments_and_missed_appointments_before_can	patient_status	patient_type	time_of_day	day_of_week	month_of_year	week_of_year	appointment_status	notice	session_left	case_type	cancelled_at	appointment_type	billable_item	category	cancelled	appointment_start_time	business_name	concession_type	customer_type	title	state	date_of_birth	sex	post_code	city	occupation	referred	total_closed_invoices_before_appointemnt
160213	Expired	NaN	12.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Tuesday	February	7.0	Not Rebooked	28.200833	3.0	Max Sessions	2023-02-13 01:47:57+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2023-02-14 06:00:00+00	Scarb Physio & Health	NaN	NaN	Mrs	QLD	1976-06-05	Female	4020.0	Scarborough	Validation Engineer	Yes	12.0
160214	Opened	NaN	12.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Tuesday	February	7.0	Not Rebooked	28.200833	NaN	Unlimited	2023-02-13 01:47:57+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2023-02-14 06:00:00+00	Scarb Physio & Health	NaN	NaN	Mrs	QLD	1976-06-05	Female	4020.0	Scarborough	Validation Engineer	Yes	12.0
160215	Expired	NaN	12.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Tuesday	February	7.0	Not Rebooked	28.200833	NaN	Unlimited	2023-02-13 01:47:57+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2023-02-14 06:00:00+00	Scarb Physio & Health	NaN	NaN	Mrs	QLD	1976-06-05	Female	4020.0	Scarborough	Validation Engineer	Yes	12.0
160216	Closed	NaN	4.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Monday	June	23.0	Rebooked	20.549167	0.0	Max Sessions	2023-06-04 10:17:03+00	2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher)	PhysioCall - Get Out Of Pain Plan (GOOPP)	B \| Get Out Of Pain Pre-Paid Sessions - (GOOPP)	Yes	2023-06-05 06:50:00+00	PhysioCall Gladstone	NaN	NaN	Mr	QLD	2000-07-26	NaN	4680.0	Glen Eden	Electrician	Yes	4.0
160217	Expired	NaN	0.0	0	0.0	Not Yet Actioned	New To Clinic	Afternoon	Thursday	October	41.0	Not Rebooked	28.228056	NaN	Unlimited	2022-10-12 01:01:19+00	1. ⭐️ Physiotherapy - 45 Minute Initial Consult	Physiotherapy - 45 Minute Initial Consult	A \| PHYSIOTHERAPY	Yes	2022-10-13 05:15:00+00	Scarb Physio & Health	NaN	NaN	Mr	NaN	1983-05-03	Male	NaN	NaN	NaN	No	0.0
160218	Expired	NaN	2.0	0	0.0	Not Yet Actioned	Recurring	Morning	Monday	October	43.0	Rebooked	63.668056	NaN	Unlimited	2022-10-21 05:49:55+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-10-23 21:30:00+00	Scarb Physio & Health	Student	Student	Mr	QLD	2006-04-24	Male	4020.0	KIPPA RING	Student	Yes	2.0
160219	Expired	NaN	3.0	1	25.0	Not Yet Actioned	Recurring	Morning	Thursday	November	44.0	Not Rebooked	14.337778	NaN	Unlimited	2022-11-02 07:09:44+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-11-02 21:30:00+00	Scarb Physio & Health	Student	Student	Mr	QLD	2006-04-24	Male	4020.0	KIPPA RING	Student	Yes	3.0
160220	Closed	NaN	5.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Thursday	June	24.0	Rebooked	28.778056	0.0	Max Sessions	2023-06-14 01:43:19+00	2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher)	PhysioCall - Get Out Of Pain Plan (GOOPP)	B \| Get Out Of Pain Pre-Paid Sessions - (GOOPP)	Yes	2023-06-15 06:30:00+00	PhysioCall Gladstone	NaN	NaN	NaN	NaN	1981-12-10	NaN	NaN	NaN	NaN	No	4.0
160221	Opened	NaN	5.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Thursday	June	24.0	Rebooked	28.778056	1.0	Max Sessions	2023-06-14 01:43:19+00	2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher)	PhysioCall - Get Out Of Pain Plan (GOOPP)	B \| Get Out Of Pain Pre-Paid Sessions - (GOOPP)	Yes	2023-06-15 06:30:00+00	PhysioCall Gladstone	NaN	NaN	NaN	NaN	1981-12-10	NaN	NaN	NaN	NaN	No	4.0
160222	Expired	NaN	1.0	0	0.0	Not Yet Actioned	Recurring	Afternoon	Friday	October	41.0	Not Rebooked	24.880556	NaN	Unlimited	2022-10-13 02:07:10+00	2. Physiotherapy - 30 Minute Follow Up Consult	Physiotherapy - 30 Minute Follow Up Consult	A \| PHYSIOTHERAPY	Yes	2022-10-14 03:00:00+00	Scarb Physio & Health	NaN	NaN	Ms	QLD	1987-02-07	Female	4504.0	Narangba	Office manager	Yes	1.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values